Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_ERRORS

`ALL_ERRORS` describes current errors on all stored objects (views, procedures, functions, packages, and package bodies) accessible to the current user.

Related Views

- `DBA_ERRORS` describes all current errors on all views, procedures, functions, packages, and package bodies in the database.

- `USER_ERRORS` describes all current errors on all views, procedures, functions, packages, and package bodies owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the object
`NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the object
`TYPE` | `VARCHAR2(12)` |  | Type of the object: `VIEW` `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `TYPE` `TYPE BODY` `LIBRARY` `JAVA SOURCE` `JAVA CLASS` `DIMENSION`
`SEQUENCE` | `NUMBER` | `NOT NULL` | Sequence number (for ordering purposes)
`LINE` | `NUMBER` | `NOT NULL` | Line number at which the error occurred
`POSITION` | `NUMBER` | `NOT NULL` | Position in the line at which the error occurred
`TEXT` | `VARCHAR2(4000)` | `NOT NULL` | Text of the error
`ATTRIBUTE` | `VARCHAR2(9)` |  | Indicates whether the selected row is an error (`ERROR`) or a warning (`WARNING`)
`MESSAGE_NUMBER` | `NUMBER` |  | Numerical error number (without any prefix)